﻿create procedure [Table].[CopyStructureAndData] ( @p_SourceTableName varchar(500), @p_NewTableName varchar(500) )
as
begin

  execute (
    'select * into ' + @p_NewTableName + ' from ' + @p_SourceTableName
  )

end